Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM10000
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Transaction WORK File Group Display Name: Payables Transaction Logical File
Physical Name: PM10000
Technical Name: PM_Transaction_WORK
Group Technical Name: PM_Transaction_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | BACHNUMB  | Batch Number | String | STR15_LBAU | 15 | |
Partial key to the Posting Definitions Master (SY00500).
Click to show/hideSELECT
['PM Transaction WORK File'].BACHNUMB AS 'PM Transaction WORK File-Batch Number'
,['Posting Definitions Master'].BACHNUMB AS 'Posting Definitions Master-Batch Number'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
SY00500 AS ['Posting Definitions Master']
ON
['PM Transaction WORK File'].BACHNUMB = ['Posting Definitions Master'].BACHNUMB
AND
['PM Transaction WORK File'].BCHSOURC = ['Posting Definitions Master'].BCHSOURC | ||||||
| 2 | BCHSOURC | Batch Source | String | STR15 | 15 | |
Records whether the transaction was entered in a batch or not.Click to show/hide the Batch SourcesPM_Trxent Batch
XXPM_Trxent No batch (real-time)
| ||||||
| 3 | VCHNUMWK | Voucher Number - WORK | String | STR17_LBAU | 17 | |
| 4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PM Transaction WORK File'].VENDORID AS 'PM Transaction WORK File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Transaction WORK File'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 5 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 6 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo | ||||||
| 7 | SOURCDOC | Source Document | String | STR10_Source_Document | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hideSELECT
['PM Transaction WORK File'].SOURCDOC AS 'PM Transaction WORK File-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['PM Transaction WORK File'].SOURCDOC = ['Source Document Master'].SOURCDOC | ||||||
| 8 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 9 | DOCDATE | Document Date | Date | DT | 8 | |
| 10 | PSTGDATE | Posting Date | Date | DT | 8 | |
| 11 | VADDCDPR | Vendor Address Code - Primary | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['PM Transaction WORK File'].VADDCDPR AS 'PM Transaction WORK File-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['PM Transaction WORK File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 12 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['PM Transaction WORK File'].VADCDTRO AS 'PM Transaction WORK File-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['PM Transaction WORK File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 13 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['PM Transaction WORK File'].PYMTRMID AS 'PM Transaction WORK File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PM Transaction WORK File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 14 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Transaction WORK File'].TAXSCHID AS 'PM Transaction WORK File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction WORK File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 15 | DUEDATE | Due Date | Date | DT | 8 | |
| 16 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 17 | DISCDATE | Discount Date | Date | DT | 8 | |
| 18 | PRCHAMNT | Purchases Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | CHRGAMNT | Charge Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 20 | CASHAMNT | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 21 | CAMCBKID | Cash Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PM Transaction WORK File'].CAMCBKID AS 'PM Transaction WORK File-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Transaction WORK File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 22 | CDOCNMBR | Cash Document Number | String | STR20_Document_Number | 20 | |
| 23 | CAMTDATE | Cash Amount Date | Date | DT | 8 | |
| 24 | CAMPMTNM | Cash Amount Payment Number | String | STR20_LBAU | 20 | |
| 25 | CHEKAMNT | Check Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 26 | CHAMCBID | Check Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PM Transaction WORK File'].CHAMCBID AS 'PM Transaction WORK File-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Transaction WORK File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 27 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 28 | CAMPYNBR | Check Amount Payment Number | String | STR20_LBAU | 20 | |
| 29 | CRCRDAMT | Credit Card Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 30 | CCAMPYNM | Credit Card Amount Payment Number | String | STR20_LBAU | 20 | |
| 31 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 32 | CARDNAME | Card Name | String | STR15_Card_Name | 15 | |
| 33 | CCRCTNUM | Credit Card Receipt Number | String | STR20_Document_Number | 20 | |
| 34 | CRCARDDT | Credit Card Date | Date | DATE | 6 | |
| 35 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Transaction WORK File'].CURNCYID AS 'PM Transaction WORK File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Transaction WORK File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 36 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PM Transaction WORK File'].CHEKBKID AS 'PM Transaction WORK File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Transaction WORK File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 37 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
| 38 | UN1099AM | Unapplied 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 39 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 40 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 41 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 42 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | MSCCHAMT | Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 44 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
| 45 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PM Transaction WORK File'].SHIPMTHD AS 'PM Transaction WORK File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM Transaction WORK File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 46 | DISAMTAV | Discount Amount Available | Currency | DLR17_RBS0_UTR$ | 17 | |
| 47 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 48 | APDSTKAM | Applied Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 49 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 50 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 51 | TXENGCLD | Tax Engine Called | Boolean | YN | 0 | |
| 52 | PMWRKMSG | PM WORK Messages | Long Integer | ML_PM_WORK_Messages | 0 | |
| 53 | PMDSTMSG | PM Distribution Messages | Long Integer | ML_PM_Distribution_Messages | 0 | |
| 54 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 55 | PGRAMSBJ | Percent Of Gross Amount Subject | Integer | INT5_RBS2_U% | 5 | |
| 56 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 57 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 | |
| 58 | PSTGSTUS | Posting Status | Integer | INT | 0 | |
Click to show/hide Posting Status
10 A transaction being entered for the first time, before it has been saved by the used.
20 A saved but unposted transaction.
30 A transaction that is currently realtime posting.
40 A posted transaction.
50 A transactions that has encountered an error during posting.
60 A transaction that has been saved previously and has a status of 20 is now being edited by the user.
70 A transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user.
| ||||||
| 59 | POSTED | Posted | Boolean | True/False | 0 | |
| 60 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 61 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Transaction WORK File'].VCHRNMBR AS 'PM Transaction WORK File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Transaction WORK File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Transaction WORK File'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 62 | CNTRLTYP | Control Type | Integer | INT1 | 1 | |
The Control Type records the type of transaction.
Click to show/hide Control Types0 Voucher types
1 Payment types
2 Printed alignment forms | ||||||
| 63 | MODIFDT | Modified Date | Date | DT | 8 | |
| 64 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PM Transaction WORK File'].MDFUSRID AS 'PM Transaction WORK File-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Transaction WORK File'].MDFUSRID = ['Users Master'].USERID | ||||||
| 65 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 66 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PM Transaction WORK File'].PTDUSRID AS 'PM Transaction WORK File-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Transaction WORK File'].PTDUSRID = ['Users Master'].USERID | ||||||
| 67 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PM Transaction WORK File'].NOTEINDX AS 'PM Transaction WORK File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PM Transaction WORK File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 68 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 69 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 70 | BKTPURAM | Backout Purchases Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 71 | PCHSCHID | Purchase Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Transaction WORK File'].PCHSCHID AS 'PM Transaction WORK File-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction WORK File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 72 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Transaction WORK File'].FRTSCHID AS 'PM Transaction WORK File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction WORK File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 73 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PM Transaction WORK File'].MSCSCHID AS 'PM Transaction WORK File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM10000 AS ['PM Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM Transaction WORK File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 74 | PRINTED | Printed | Boolean | CB | 0 | |
Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
| 75 | PRCTDISC | Percent Discount | Integer | INT5_%2 | 5 | |
| 76 | RETNAGAM | Retainage Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 77 | ICTRX | IC TRX | Boolean | CB_IC_TRX | 0 | |
Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany | ||||||
| 78 | ICDISTS | ICDists | Boolean | Boolean | 0 | |
Click to show/hide Intercompany distirubtions
0 Not intercompany.
1 Intercompany distributions present. | ||||||
| 79 | PMICMSGS | ICMessages | Long Integer | ML_IC_Post_Messages | 0 | |
Error messages from posting an Intercompany Transaction.
Click to show/hide Intercompany posting error messages
1 The currency ID is missing.
2 A destination company does not have access to this currency ID.
3 The currency ID is inactive for a destination company.
4 A rate type ID is missing for a destination company.
5 Rate type ID is not associated with the currency ID for a destination
company.
6 An exchange table ID is missing for a destination company.
7 A destination company does not have access to an exchange table ID.
8 An exchange table ID is inactive for a destination company.
9 An exchange rate does not exist for a destination company.
10 An exchange rate has expired for a destination company.
11 Cannot post intercompany multicurrency transactions to a recurring batch.
12 A rounding account missing for a destination company.
13 A distribution type is invalid for a destination company distribution.
14 A destination company distribution contains MDA information.
15 A destination company ID does not exist; please select another company ID.
16 The user does not have access to a destination company.
17 A destination company does not have a functional currency set up.
18 Destination functional currency doesn't match originating functional currency.
19 No relationship exists between originating company and a destination company.
20 Due To / Due From account not specified.
21 The rounding account does not exist for the originating company.
22 Unknown SQL error occurred.
23 Intrastat information is missing or invalid.
24 The goods value for Intrastat exceeds the document total.
25 Transaction has successfully posted. | ||||||
| 80 | Tax_Date | Tax Date | Date | DT | 8 | |
| 81 | PRCHDATE | Purchase Date | Date | DT | 8 | |
| 82 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 83 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 84 | CORRNXST | Correction to Nonexisting Transaction | Boolean | Boolean | 0 | |
| 85 | VCHRNCOR | Voucher Number Corrected | String | STR20_LBAU | 20 | |
| 86 | PMWRKMS2 | PM WORK Messages 2 | Long Integer | ML_PM_WORK_Messages_2 | 0 | |
| 87 | BNKRCAMT | Bank Receipts Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 88 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 89 | Electronic | Electronic | Boolean | CB_Electronic | 0 | |
| 90 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
| 91 | DocPrinted | DocPrinted | Boolean | CB_DocPrinted | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
| 92 | TaxInvReqd | Tax Invoice Required | Boolean | CB_Tax_Invoice_Required | 0 | |
| 93 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 94 | CBVAT | Cash Based VAT | Boolean | CB_CashBasedVAT | 0 | |
| 95 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 | |
| 96 | TEN99BOXNUMBER | 1099 Box Number | Integer | DDL_1099_Box | 0 | |
| 97 | Workflow_Status | Workflow Status | Integer | Workflow Status | 0 | |
| 98 | InvoiceReceiptDate | Invoice Receipt Date | Date | DT | 8 | |
| Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade. | ||||||
| 99 | LNGDESC | Long Description2 | String | STR200 | 200 | |